/*
	This script contains the create statement for that importing process.
	
	@autor Victor Regalado
	@date 04/14/2010
*/

CREATE TABLE [dbo].[department_SDI] (
[dpt_no]  SMALLINT,
[dpt_name] VARCHAR(20),
[dpt_mgrssn] CHAR(9),
[dpt_mgr_start_date] datetime
)

CREATE TABLE [dbo].[dept_locations_SDI] (
[dpt_no] SMALLINT,
[dpt_location] VARCHAR(20)
)

CREATE TABLE [dbo].[dependent_SDI] (
[dep_emp_ssn] CHAR(9),
[dep_name] VARCHAR(50),
[dep_gender] CHAR(1),
[dep_date-of_birth] datetime,
[dep_relationship] VARCHAR(10)
)

CREATE TABLE [dbo].[employee_SDI] (
[emp_ssn]  CHAR(9) NOT NULL,
[emp_last_name] VARCHAR(25),
[emp_first_name] VARCHAR(25),
[emp_middle_name]VARCHAR(25),
[emp_address] VARCHAR(50),
[emp_city] VARCHAR(25),
[emp_state] CHAR(2),
[emp_zip] CHAR(9),
[emp_date_of_birth] datetime,
[emp_salary] money,
[emp_parking_space] int,
[emp_gender] CHAR(1),
[emp_dpt_number] SMALLINT,
[emp_superssn] CHAR(9),
[company] CHAR(4),
[post_merge_salary] money
)

CREATE TABLE [dbo].[equipment_SDI] (
[eqp_no] CHAR(4),
[eqp_desc] VARCHAR(15),
[eqp_value] MONEY,
[eqp_qty_on_hand] SMALLINT,
[eqp_total_value] MONEY,
[eqp_pro_number] SMALLINT,
[eqp_owner] char(10)
)

CREATE TABLE [dbo].[project_SDI] (
[pro_number] SMALLINT,
[pro_name] VARCHAR(25),
[pro_location] VARCHAR(25),
[pro_dept_number] SMALLINT,
[company] char(4)
)